This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Mark Refoopuloopsi 20.Jan.04 06:30 PM a Web browser Domino Designer6.0.3Windows 2000; Windows XP
I have a challenge that I could use some assistance with. I have to devise a way for our users to create a 'ticket' and schedule when it will be sent out.
The options need to be
1) Daily
2) Weekly
3) Monthly
4) on the Nth (ie: 1st, 12th, 22nd, etc.) day of the month
5) every Nth week of the month on the X day of that week.
6) every Nth day (Monday, Thursday, Saturday, etc) of the month
I am trying to come up with an agent that will set a field with the first date that meets the criteria and then when the agent runs against it, change the field to the next date.
The Daily, Weekly and Monthly options are easy. It is the last two options that are causing me problems.
How do I determine the date of the first Sunday of the month or the 3rd Wednesday or the Monday in the 2nd (or 3rd or 4th) week of the month?
Anyone have any examples (formula or script) that could help with this problem?
Return to top
Print this page
